import requests
from bs4 import BeautifulSoup as bs
import json
import csv
import re
import pandas as pd
import numpy as np

COMMENT_PAGE_URL = []


def Get_Url(url):
    g_url = url.split('Page=1')
    for i in range(0, 100):
        COMMENT_PAGE_URL.append(g_url[0] + 'Page=' + str(1 + i) + g_url[1])
    for i in range(0, 100):
        gg_url = g_url[0] + 'Page=' + str(1 + i) + g_url[1]
        gg_url = gg_url.split('append=0')

        COMMENT_PAGE_URL.append(gg_url[0] + 'append=1' + gg_url[1])


def GetInfo(num):
    nickname = []
    Id = []
    auctionSku = []
    ratecontent = []
    ratedate = []
    shopid = []
    contentt = []
    days = []
    content_date = []
    for i in range(num):

        if (i % 10 == 0):
            print(COMMENT_PAGE_URL[i])
        headers = {
            'cookie': 'cna=qMU/EQh0JGoCAW5QEUJ1/zZm; enc=DUb9Egln3%2Fi4NrDfzfMsGHcMim6HWdN%2Bb4ljtnJs6MOO3H3xZsVcAs0nFao0I2uau%2FbmB031ZJRvrul7DmICSw%3D%3D; lid=%E5%90%91%E6%97%A5%E8%91%B5%E7%9B%9B%E5%BC%80%E7%9A%84%E5%A4%8F%E5%A4%A9941020; otherx=e%3D1%26p%3D*%26s%3D0%26c%3D0%26f%3D0%26g%3D0%26t%3D0; hng=CN%7Czh-CN%7CCNY%7C156; x=__ll%3D-1%26_ato%3D0; t=2c579f9538646ca269e2128bced5672a; _m_h5_tk=86d64a702eea3035e5d5a6024012bd40_1551170172203; _m_h5_tk_enc=c10fd504aded0dc94f111b0e77781314; uc1=cookie16=V32FPkk%2FxXMk5UvIbNtImtMfJQ%3D%3D&cookie21=U%2BGCWk%2F7p4mBoUyS4E9C&cookie15=UtASsssmOIJ0bQ%3D%3D&existShop=false&pas=0&cookie14=UoTZ5bI3949Xhg%3D%3D&tag=8&lng=zh_CN; uc3=vt3=F8dByEzZ1MVSremcx%2BQ%3D&id2=UNcPuUTqrGd03w%3D%3D&nk2=F5RAQ19thpZO8A%3D%3D&lg2=U%2BGCWk%2F75gdr5Q%3D%3D; tracknick=tb51552614; _l_g_=Ug%3D%3D; ck1=""; unb=3778730506; lgc=tb51552614; cookie1=UUBZRT7oNe6%2BVDtyYKPVM4xfPcfYgF87KLfWMNP70Sc%3D; login=true; cookie17=UNcPuUTqrGd03w%3D%3D; cookie2=1843a4afaaa91d93ab0ab37c3b769be9; _nk_=tb51552614; uss=""; csg=b1ecc171; skt=503cb41f4134d19c; _tb_token_=e13935353f76e; x5sec=7b22726174656d616e616765723b32223a22393031623565643538663331616465613937336130636238633935313935363043493362302b4d46454e76646c7243692b34364c54426f4d4d7a63334f44637a4d4455774e6a7378227d; l=bBIHrB-nvFBuM0pFBOCNVQhjb_QOSIRYjuSJco3Wi_5Bp1T1Zv7OlzBs4e96Vj5R_xYB4KzBhYe9-etui; isg=BDY2WCV-dvURoAZdBw3uwj0Oh2yUQwE5YzQQ9qAfIpm149Z9COfKoZwV-_8q0HKp',
            'user-agent': 'Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/63.0.3239.132 Safari/537.36',
            'referer': 'https://detail.tmall.com/item.htm?spm=a1z10.5-b-s.w4011-17205939323.51.30156440Aer569&id=41212119204&rn=06f66c024f3726f8520bb678398053d8&abbucket=19&on_comment=1&sku_properties=134942334:3226348',
            'accept': '*/*',
            'accept-encoding': 'gzip, deflate, br',
            'accept-language': 'zh-CN,zh;q=0.9'
        }
        content = requests.get(COMMENT_PAGE_URL[i], headers=headers).text
        sid = re.findall('"currentMilles":(\d+)', content)

        nk = re.findall('"displayUserNick":"(.*?)"', content)
        nickname.extend(nk)
        Id.extend(re.findall('"id":(\d+)', content))
        # print(Id)

        if COMMENT_PAGE_URL[i].split('append=')[1][0] == '1':
            content_date.extend(re.findall('"commentTime":"(.*?)"', content))
            days.extend(re.findall('"days":(\d+)', content))
            contentt.extend(re.findall('"content":"(.*?)"', content))
        else:
            content_date.extend(len(nk) * [''])
            days.extend(len(nk) * [''])
            contentt.extend(len(nk) * [''])

        auctionSku.extend(re.findall('"auctionSku":"(.*?)"', content))
        ratecontent.extend(re.findall('"rateContent":"(.*?)"', content))
        ratedate.extend(re.findall('"rateDate":"(.*?)"', content))
        shopid.extend(sid * len(nk))

    data = pd.DataFrame(
        np.array([shopid, Id, nickname, auctionSku, content_date, contentt, days, ratecontent, ratedate]).T,
        columns=['商品ID', '评论ID', '用户昵称', ' 颜色分类', '追评时间', '追评内容', '追评天数', '评论内容', '评论时间'])
    return data


url = [
    'https://rate.tmall.com/list_detail_rate.htm?itemId=591661171647&spuId=1192954587&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvhvvBvLvvUvCkvvvvvjiPn2cv1jtWR25OQjYHPmPWljtnRFzW1j1RPsz91jlE9phvheCfYaGzzHi47imkzAcj5d0kSFyCvvpvvvvviQhvCvvv9UUPvpvhvv2MMQhCvvOvCvvvphvEvpCWmW%2F4vvaw1W1ldEZ78BLhQW2We3O0747B9Wma%2BoHoDO2UQC6tExjxAfev%2Bul1b8A%2B%2B87JecaCtb2XSfpAOH2%2BFOcn%2B3CAp%2FFEDaVTR4yCvv9vvUmgKvFnyUyCvvOUvvVCJhetvpvIvvvvvhCvvvvvvUEpphvWh9vv9DCvpvQovvmmZhCv2npvvUEpphvWhFyCvvpvvvvv3QhvCvvhvvmCvpvW7DlGt6bw7Di4XbNNdphvmpvUv9CvpvvQ1OhCvCE9cKPNHB147DizRrGD1tTYIdgtvpvhvvvvv86CvvGOCP6vTKIvlRyidAUF4thtvpvhvvvvvv%3D%3D&needFold=0&_ksTS=1589015260284_619&callback=jsonp620',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=526934723097&spuId=1607306360&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvhpvxvcyvUpCkvvvvvjiPn2cv1jlHn2L96jEUPmPUQjEhn2Lw6jrnRL5pljr8nUhCvv147Ybzwa147DuZvr%2FrvpvBCU2ytzOvvEB1EBYb3Oy3%2B2ervpvEvUhMPuwvvv4KRphvCvvvphmCvpvoOH04zlpw7Di4cGfNEwJJS48%2FiQhvCvvvpZptvpvhvvCvpvGCvvpvvvvvKphv8vvvpHwvvvvgvvCHtpvvvcWvvhcDvvmCp9vvBJZvvUhfvvCHtpvv9XuivpvUvvCCWRW5pgkEvpvVvpCmpJ2hmphvLvEaLZ6aiXTAdX3l8PsOjEAXjcn86Wp7RqJ6EvLvqbVQKfE9Z%2BsIRfUTKFEw9E7re4TJEcqUaB4AdByaUExre4g7%2B3%2BFaNoAdBAK4QgCvpvVvUCvpvvv3QhvCvmvphmCvpvJfH6hzlFw7Di4cpfNoIdvSGRj%2FkWU4w5C3q6qZ6uURphvCvvvphmrvpvEvU2DtrZvvUrDdphvmpmvu4SVvvmn9T6CvCm29P5T%2FpvvyNk1b6jBDLwTdphvmpmvj1ATvvmxKFyCvvpvvhCv&needFold=0&_ksTS=1589016904209_568&callback=jsonp569',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=574264689773&spuId=1016200951&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvzvvPvovvUpCkvvvvvjiPn2cv1jlhRFFpsjivPmPhzjtbnLd90jYPn2Fh6j1UPT6CvvyvCb%2FCKb9veVKrvpvEvvL9vFp6vmLQRphvCvvvvvmCvpvJjSQ3cijNznswSbE4wgRIkveCS%2BPkRG5U9ZFVAcW2iQhvCvvv9UUtvpvhvvvvvvhCvvOvCvvvphmtvpvIvvvvk6CvvWhvvvhophvUeQvv9DCvpvQovvmmZhCv2n9vvUEpphvWl8yCvv9vvUmgKj80BOyCvvOUvvVCJhyEvpCWC2oevvaFD4mxfX9fjLoQD7zheutYVVzhlj7x%2B3%2Bugj7QiXT4w62U%2BneYr2E9ZRAn3w0AhjHCTWex6fItb9Txfa3l5dhfb57QiNo4e9GCvvpvvvvv3QhvCvvhvvmCvpvZzPAlcBzNznswgwaft%2F2wBnQb7e9tvpvhvvvvvv%3D%3D&needFold=0&_ksTS=1589016975037_402&callback=jsonp403',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=18883232669&spuId=1350177115&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvVvvpvLyvUvCkvvvvvjiPn2cv1j1WPsdhQj1VPmPw1jYjR2sOsj1nnLqpljnh3QhvCvvhvvvPvpvhvv2MMQhCvvOvCvvvphmivpvUvvmvKb3sHA0EvpvVmvvC9c3EKphv8vvvvv%2FMpvCjvvmmZhCvmE%2BvvUEpphvWh9vv9DCvpvsOvvmmZhCv2npEvpCWvjL7vvwYAXcBlLyzOvxrljc6%2Bul08qmDYnmXVcEJ0f0DyBvOJ1kHsX7vV16AxYjxAfyp%2B3%2Busjc6D40OwAT%2BkbeahBODN%2BLhaNoAdLyCvvpvvvvviQhvCvvv9U8CvpvJfH66z15w7Di4cTbNoIdvSGRj%2FkWU4w5C3q6qZ6uURphvCvvvvvmCvpvoOH66z1yw7Di4Oa5NEwJJS48%2FRphvCvvvvvmrvpvPVvLxv8oyvHmk84GkU0KBdphvmpvh%2Bvb2QQvCsu6CvCh9vV0m40%2BvmBhidTv6pWDxWp%3D%3D&needFold=0&_ksTS=1589017053843_355&callback=jsonp356',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=17097598795&spuId=1027827265&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvwQvRvB%2BvUpCkvvvvvjiPn2cv1j1Wn2F96j1VPmPvsjEmPsqO6j1RPFcw0jlWn2yCvvpvvhCv9phvje1axnYgzHi47D%2FYz6u8QbM23MIFmV5EQOJYRln8kUwCvvpv9hCvRphvCvvvphmivpvUvvCCWRWsQxkEvpvVvpCmpJ2hKphv8vvvpHqMMQ2IvvCHtpvvvcWvvhcDvvmCp9vvBJZvvUhfvvCHtpvv9XIEvpCW9Ohbm10BhC97%2B3%2BraNoAdXKKfvDrz8TJ%2Bull8bmxdXuK5FrV%2BE7r58TJO34YLBh7%2BultEPoxdXAKD7U7A4ZzhB4AVAElYb8r58tdophCvvOv9hCvvvvPvpvhvvvvv8wCvvpvvhHhRphvCvvvphmCvpvoOHlZzz9w7Di4OOjNEwJJS48%2FdphvhQ7vWFnLvvv8hAZNxd7aUfJzRk9%3D&needFold=0&_ksTS=1589017093497_371&callback=jsonp372',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=39451855306&spuId=992112757&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=0&groupId=&ua=098%23E1hvpvv7v3WvUpCkvvvvvjiPn2cv1j1nRsShAjD2PmPh0j1URsFU6jiPPFsZAj3URUhCvvswz2BJvaMwznQVuxItvpvhvvvvvUhCvvswz2rJ7aMwzn1a8DurvpvEvvC0v5EAvmskRphvCvvvvvmCvpv%2BgPQNc4FNznsw5CE4WzRCoeiI1G5TpJeUmVkMshhsoIHUAwN8Z6KUu7umFUurvpvEvvB7vfuTvCBaRphvCvvvvvvCvpvVvvpvvhCvmphvLCBG4QvjXjjxQWAOe31iQWsU0mTTwhPUzjjxVED1ojjxQWQXjVERD7zWaXgBOyTxfwBl533%2BCNLh0now5oEpDO7rqbVQWl4v1R2I%2Bu0EvpvVmvvC9c3Euphvmvvv9bkgafRUKphv8vvvvv%2FMpvCjvvvChyCvmE%2BvvUEpphvWh9vv9DCvpvsOvvmmZhCv2npPvpvhvvvvv8wCvvpvvUmm3QhvCvvhvvmrvpvi9vLe9xlavm2rdfe7blexAfVHSEOFLqznDfolK76RSfcCSLJAbDdZAWmCvpv6gPQIcwFNznswMXtftsfwKYAY7eyswgjEuIFW1K8F9Z3iAw0MpLn89ZFE1GiLogki4I8WkFyCvvpvvvvvdphvhkpU9vU2vQvtakeS8oxLiXcas46CvmX6CvOmwzWvpLZidAy3xXxaiah6I2CvDfeB1EIwJZ5hzWLpV3iQBOhCvms9z2BJUaMwzn1VHHIu6kOU4Ik1Qz%2BfivDi4dMWgFrivIbFygi3ypEkOe88FQ%3D%3D&itemPropertyId=&itemPropertyIndex=&userPropertyId=&userPropertyIndex=&rateQuery=&location=&needFold=0&_ksTS=1589017198756_584&callback=jsonp585',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=45459623399&spuId=294682505&sellerId=700459267&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvcQvovZyvjQCkvvvvvjiPn2cv1j1RPFMOljrCPmPWlj1ERFSy0j3bPFqhgj6tvpvhphvvv86CvvDvp7hWJ9CvXqurvpvEphH7CCwvpHsx9phvheCaCnY7jHi47eE9zAcj5d0kSIhCvCt%2BcZL5zY147DiN3YY8k%2BmMQgNTUQ3iAwVjSLrLoIkjvpvhphhvv2yCvvBvpvvv2QhvCvvvvvmEvpvVpyUU2CAOuphvmhCvCWxGX%2Fh2Kphv8hCvvjFMM6mBphvZ99vvpuBvpComvvC216CvHUUvvhnlphvZ99vvpzOEvpCWpjHtv8WOJ193Zi7veCrTmmxBlwyzhmx%2FJoL60fJ6EvBQcExreC9aUmx%2F6jZ7%2B3%2Buwos66EK4fvyf8r1l53HkLkx%2F1RoK55BWw6PUdvhCvvXvppvvvvm5vpvhphvhH2yCvvBvpvvvdphv26XHW92YvhCjNFBYhfhyE2yCvvBvpvvv9phv2HifuSaczHi47IULzQ%3D%3D&needFold=0&_ksTS=1589017234287_422&callback=jsonp423',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=524011612556&spuId=862584106&sellerId=217101303&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvKQvLvxwvUvCkvvvvvjiPn2cv1j1RRLSv0jthPmPZ6jEmR2qpQjYEP2zpQjYV9phvHHif6S%2F9zHi47IRdtMQv7yE4gnYUdphv2QRv5tYdvvvRmoZN7g63WFyCvvpvvhCv9phv2HifNrGOzHi475xOzT6Cvvyv9C6a19vvmSptvpvhvvCvp8wCvvpvvhHhmphvLv8B%2FM%2BaaXT1dXIaW4c6eEQ4eeQ4S4ZAhCkaU6bnDBmOe36AxYjxRLwprj6OfwmK5t9Xa6bI1EAfeCO0747BhCka%2BoHoDOmOV16tExVtvpvIvvCvcSMMvR9vvhcDvvvCwQvvBJZvvUHmvvCHtpvv9B%2BvvhcDvvmCeuyCvv9vvhhQgsGorUyCvvOCvhECgWpCvpvVvUCvpvvv2QhvCvvvMMGtvpvhvvCvpUwCvvpv9hCv9phv2HiacnYOzHi47eUFzghCvCE9cxsN7C147Diy7nGD1tTYIdgtvpvhvvCvp86CvChh9UmhyvvvHHODj6KHkoVQRp%3D%3D&needFold=0&_ksTS=1589017267960_649&callback=jsonp650',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=526415737630&spuId=836429505&sellerId=217101303&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=0&groupId=&ua=098%23E1hvVpvXvN9vUpCkvvvvvjiPn2cv1j1PP2LZAjEUPmPUsjtRRsz96jlURLsvsjYURghCvvswMVaJBaMwznQ3txurvpvEvvpLvKj3v8o1dphvmpvhK9UznQmwOT6CvvyvCbZmJz%2BvePkCvpvZzPAscrFNznswpHift%2F2wwrA%2B7ekrvpvEvvodvDxxvUFhRphvCvvvvvmrvpvEvvohvelrvj9zdphvmpvhrpEKf9C6uUhCvCRGPWBas%2FMwznsaoHdAZTDuk85RRphvCvvvvvmjvpvhvvpvv8wCvvpvvUmmmphvLCmdq9vjBb0BD4mAdcyyibmxfBuKNB3r6j7%2B%2Bul1pc7QiNoXecXj%2BneYiLUpwvzlInVQrtaABSjviRQ1RoxhdJAn3feAOHNI3E5xnqVEvpvVmvvC9c3Euphvmvvv9bkgaqNHKphv8vvvvv%2FMpvCjvvmmZhCvmE%2BvvUEpphvWh9vv9DCvpvsOvvmmZhCv2npCvpvVvvpvvhCv2QhvCvvvvvvtvpvhvvvvvUhCv2L9PR1JRYMwznAwXxSzEnAqzbl44Lns9weukWsVguRCoV5EsfYCW6uCoW5jADnbk8DuQI0oRphvCvvvvvmrvpv7nvsW9DDXvh2C84Gu850H6XcEWqv%2BpUhCvCLwMHlJhaMwznAM9xSNjr1Azva44UhCvmDMMVnJbaMwznACKHIu6kOU4Ik1Qz%2BfCRdukWk%2FOOjFv%2FUmyOlXeOUkI9%3D%3D&itemPropertyId=&itemPropertyIndex=&userPropertyId=&userPropertyIndex=&rateQuery=&location=&needFold=0&_ksTS=1589017320249_781&callback=jsonp782',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=561853925065&spuId=1021014762&sellerId=217101303&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvwQvLvxIvUvCkvvvvvjiPn2cv1j1UPLsZAjD2PmPwQjEmR2MOtjY8R2MOljlP9phv2HifZMJPzHi47Ic%2BzT6CvvDvpw6WxvCv418rvpvEphh%2FhUhvpVX7RphvChCvvvmCvpvoOHlwzMyw7Di4ObNNEwJJS48%2FRphvChCvvvmCvpvJfHlwzM5w7Di4cG5NoIdvSGRj%2FkWU4w5C3q6qZ6uUiQhvChCvCCptvpvhphvvvvGCvvpvvPMMmphvLhRNq9mFdcHCjLVDYCeOayB%2BVd0DW3CQoAnmsXZpVcIUExjxALwpEctz8SoxdB9aWox%2FQj7J%2B3%2B%2BjLVxfXkKNB9f857%2B%2BulQb7QEfwmtvpvIphvvJPMMpEHvpComvvCmihCvHUUvvhPjphvZ99vvpzXvpComvvC2aIyCvvXmp99WjEkivpvUphvh1csIR%2FhCvpvVphhvvvvv3QhvChCCvvmrvpvLoyKYCnOvpHDaHz6DrdWmfoYfI46CvvDvpayWZ9CvXgUtvpvhphvvvv%3D%3D&needFold=0&_ksTS=1589017421937_380&callback=jsonp381',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=556190224679&spuId=1088100746&sellerId=217101303&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvivvLvxWvUpCkvvvvvjiPn2cv1j1UR2chtjljPmPUsjrbn2Mvtj3bn259QjiEROhCvCLwM8la2aMwznQ9PxS5gn1ezR14486Cvvyv9jx0oQvvyVRrvpvEvUh5EeIvvUXr9phvhiQGTDu%2FqYswzn0J7kdoXhFD4UhCvvswPRY4CYMwznAwiHIPvpvhvvvvvvyCvhQvGYcxjahZ%2Bu0OJm7y%2Bb8reC%2BaUWmQ%2Bu0OV169D70Oeug7Ecqhl8TJ%2Bul1Bj7%2BeC4AdcHEaNoAdX9fjLVxfXAK5dUf8z7g%2BLoQRpn%2BKphv8vvvpHqMMQ2IvvCHtpvvvcWvvhcDvvmCp9vvBJZvvUV4vvCHtpvv9XuivpvUvvCCWRnbmc4EvpvVvpCmpJ2hvphvC9mvphvvv2yCvvpvvhCviQhvCvvvpZojvpvhvUCvp2yCvvpvvhCvRphvCvvvphmCvpvWzPQi7SqNznswc3x4RphvCvvvphmrvpvLCpmkIgWvvvqVEBY7rX63rqwT8v%3D%3D&needFold=0&_ksTS=1589017458395_724&callback=jsonp725',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=44578925759&spuId=870255851&sellerId=217101303&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hv1QvLv7IvjQCkvvvvvjiPn2cv1j1URsSy0jivPmPWgj3PPLFw1jibPsdhsjuCvpvWzPAdcwqNznswOjt4dphvhURCbAgQvvvb2dhSpaVxnsItvpvhvvCvpUhCvC8wPnt4dKMwznQYklIu6eBUt7kCvpvo52sQ7eqSznswSPx48rEyoRxI9phvj3gGgxdezYswzHs075R2uU9E9fq2gFSEAUHU1%2BDsvTwCvvpvvhHhmphvLvhrT%2F%2BaiLUpVE6Fp%2B0xhCeOjLEc6aZtn1mAVAElYb8rVTgfNezpdug7%2B3%2BuQj7J%2Bu0wjLRt3f4AHdBYoRLZeBOqrADn9Wma%2BfmtEp7tvpvIvvCvcSMMvR9vvhcDvvvCwQvvBJZvvUHmvvCHtpvv9XIvvhcDvvmCeuyCvv9vvhhQg6SCiUyCvvOCvhECgWpCvpvVvUCvpvvv2QhvCvvvvvvtvpvhvvCvpUwCvvpv9hCvRphvCvvvphvtvpvhvvCvp86CvCWHvUoH1pvv20hDjl4l5oVzrsIIdphvmpmvmvKLvvmBtQ%3D%3D&needFold=0&_ksTS=1589017487511_381&callback=jsonp382',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=593514532864&spuId=1007277469&sellerId=2756817964&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvq9vLvxZvUpCkvvvvvjiPn2cv1j1EPLM9lj1VPmPv6jEvP2spAjrRPsMyzj1nP46CvvyvC8Qmo6%2BvvXkCvpvLOxAJY0Qw7Di4NszNoW5UsdMUJsyCvvpvvvvvRphvCvvvvvmjvpvhvvpvvbyCvm9vvvvPS6vvBQvv9DCvpvkfvvmmZhCv2CUvvUEpphvWlvvv9DCvpvsZuphvmvvv9bkg4sQVkphvC99vvOHgopyCvhQhqXvvClsUaNsOe1iToG2yAWp7RAYVyO2vqbVQWl4v0RFE%2BFIlBqevD704d56Ofa1l%2BboJEcqZaNswV31ToaFygbvqrADn9W2%2BFfmtvphvC9vhvvCvpvGCvvpvvvvvRphvCvvvvvm5vpvhvvmv9IhCvv14cxsS3r147Di3oa%2FCvpvW7Dlwqg5w7Di4XqjNdphvmpvU3UjrqpmUtsyCvvpvvvvvdphvHmQhxIVH3p2I5keSULELKXhH6LIt9phvHHifQSJPzHi47i60tMQv7St46YYU&needFold=0&_ksTS=1589017531537_427&callback=jsonp428',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=594009630945&spuId=1007277469&sellerId=2756817964&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hv2vvovZIvUvCkvvvvvjiPn2cv1j1ERFqO0jrCPmP91jibRsd91jYnRsLv0jDndphvhCQhrIjH1pC6BO0znsBBKaVrvpvEvvLF9oGSvVmhdphvmpvWAO2q%2FQvGXFyCvvpvvvvv9phvje1annYOzHi47eHhz6u8QbM23MIFmV5EQOJYRln8kvhCvvOvCvvvphvEvpCWmU%2FPvvawQj7QD46OjomUkbmxdBIaUUlrljZ7%2B3%2BraNLXSfpAOHmQD7zyditQc8c61WQXVjCw0f0DyBvOJ1kHsX7vVB3TmEcBlwyzh8yCvv9vvUmgKV%2BqyUyCvvOUvvVCJhetvpvIvvvv2qYvvhwvvUEpphvUeQvv9DCvpvQovvmmZhCv2npvvUEpphvWlvGCvvpvvPMMRphvCvvvvvm5vpvhvvmv9IwCvvpvCvvvRphvCvvvvvmCvpvoOH66zl9w7Di4O6bNEwJJS48%2F9phv2Hif9SaPzHi47ILkzsyCvvpvvvvv&needFold=0&_ksTS=1589017573787_384&callback=jsonp385',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=612273231114&spuId=1041332153&sellerId=2756817964&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hv99vBvZQvjQCkvvvvvjiPn2cv1j18P25hgjljPmPW1jtPP2dhAjYjRFcp0jWtvpvhphvvvUhCvCB471Szan147DiMdRNGvHi%2B7%2BsNo86CvCHUoJhpjvCvXVGDNpZTRFE5286CvvYVB2pvA9Cv7So%2FNBV1EmptvpvhphvvvUhCvCE9cosNJC147Di3paGD1tTYIdTCvpvJfH6%2BzzFw7Di4c1PNoIdvSGRj%2FkWU4w5C3q6qZ6uU3QhvChCCvvm5vpvhphvhHvhCvvXvppvvvvmivpvUphvh1c1unj4EvpvVpyUU2CAOKphv8hCvvjFMM6mBphvZ99vvpuBvpComvvC216CvHUUvvhn0phvZ99vvpzOEvpCWpWQGv8R1UxUDCwL9jLyDZLxjKOmAdcHmjomxfX9fjLhiHR2weB1%2BVkYVyOvO5onmWl4v1EQaWDw6pwethbUf85piYE7rejpi46etlpGCvvpvvvvvRphvChCvvvvtvpvhphvvvv%3D%3D&needFold=0&_ksTS=1589017615102_385&callback=jsonp386',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=523047215600&spuId=1202785030&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvpQvPvLvvUvCkvvvvvjiPn2cv1j18R2dh6jEUPmPvgj1UPLMO0jYPP2qwgjrRRphvCvvvphmjvpvhvUCvp8wCvvpvvhHhRphvCvvvphvPvpvhvv2MMqyCvm9vvhCJMMGvTvvvBJZvvvHsvvCHtpvv9ZUvvhcDvvmCe9vvBJZvvUV4uphvmvvvpL2FxQukkphvC9hvpyj91vyCvhQmKZlnj70AdXkXjZmQD40OeutYVVzh58gJ55BOiNoweEQ4fCuYiLUpVE6Fp%2B0xhE9wjLEc6aZtn1mAVAilYb8re8tdoOcB%2BdhBHkx%2FvphvC9mvphvvv86CvC%2BE9wfVDQvv9SmtnxRxiXOArbv%2Bpt06%2BL4zKo7CvpvJfHzszYFw7Di4OUjNoIdvSGRj%2FkWU4w5C3q6qZ6uURphvCvvvphmCvpvoOHzszY9w7Di4OkdNEwJJS48%2FdphvmpmvZHHGvvmndp%3D%3D&needFold=0&_ksTS=1589017655070_470&callback=jsonp471',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=532919865476&spuId=917733641&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvXvvovZ%2BvjQCkvvvvvjiPn2cv1j18nLzWAjljPmP96jnhPsqhzjnVR2FhgjArvpvEvvp5vIR2vRoxRphvCvvvvvmCvpvJfHlwztFw7Di4cg5NoIdvSGRj%2FkWU4w5C3q6qZ6uU3QhvCvvhvvm5vpvhvvmv9FyCvvpvvvvvmphvLvA8S9vjbGFvAW9OejCCgnFwiC40f3qxs4V9eEB%2BvfFClw66HjCX%2BExrA8TJfxAQA42WH3D%2Bm7zUa4p7%2B3%2BiaNolK2kzWCky%2BExre4TtvpvIvvvv2qYvvhwvvUEpphvUeQvv9DCvpvQovvmmZhCv2npvvUEpphvWl8yCvv9vvUmgKV6L%2FIyCvvOUvvVCJhyCvpvVvvpvvhCv2QhvCvvvvvvtvpvhvvvvvUhCvCE9cxLNJC147DiyMYGD1tTYIdTrvpvEvvk29yXVvbQYdphvmpvhUO8Xep2WaIhCvCB47lbMJr147DuxIRNGvHKd7rPNo2yCvvpvvvvv&needFold=0&_ksTS=1589017706788_853&callback=jsonp854',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=540221396299&spuId=706283519&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hv%2FQvBvZ9vUvCkvvvvvjiPn2cv1j1bPsz9sjljPmP9sjrWn2qyQjnVPsdwgjtERphvChCvvvmrvpvEphhHhjvvpV9Cdphvh6ibkvBmvhCXYbtYEf4sve6S7ThtvpvhphvvvUhCvCE9cZsNr1147Di9HYGD1tTYIdgtvpvhphvvvUhCvCt%2BcZsNrY147DiJYrY8k%2BmMQgNTUQ3iAwVjSLrLoIkjvpvhphhvv8wCvvBvpvpZvphvCyCCvvvvvvyCvh1v10hvItQanerjiNo4VzHVfCuYiLUpwh%2BFp%2B0xhEiTmmxBlwyzhmx%2Fwmz61C46NZxQBWmQRqwiL7CpqU0QKoZHaysEDLuTWD19C7zpKphv8hCvvjFMM6mBphvZ99vvpuBvpComvvC216CvHUUvvhn0phvZ99vvpz4ivpvUphvh1c1dUrTEvpvVpyUU2CAO2QhvCvvvMMGtvpvhphvvvUhCvCB47gdMGa147Du29%2FNGvHi%2B7rPNov%3D%3D&needFold=0&_ksTS=1589017742857_408&callback=jsonp409',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=18422778614&spuId=937659826&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvIvvovL6vUvCkvvvvvjiPn2cv1j1bRFz96j3mPmPysj3WRFLy1jY8PFzvAjYV9phv2HifkMGPzHi47inyzT6CvvyvCmO2MPQvlhKrvpvEvv9C9kgKvVLXRphvCvvvvvmCvpvJfHr%2FzqFw7Di44x2NoIdvSGRj%2FkWU4w5C3q6qZ6uURphvCvvvvvm5vpvhvvmv99hCvvOvCvvvphmtvpvIvvvv2qYvvhwvvUEpphvUeQvv9DCvpvQovvmmZhCv2npvvUEpphvWlUyCvvOUvvVCJheivpvUvvmvKb3KOYvEvpCW28TKvvakfwFvaXTAVAdvafk1%2BFw5ZTVQD76Xe169D7zUA8gJEcqUQj7Q%2BulAp5c63E7rVcwu%2B8c6D46XwmzGznsZeBl1pnFpQbvqrQGCvvpvvPMMRphvCvvvvvmjvpvhvvpvvUhCvv14cbNN%2BC147Dialn%2FrvpvEvvptvKj3vRLvRphvCvvvvvv%3D&needFold=0&_ksTS=1589017776923_418&callback=jsonp419',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=579420755369&spuId=1085615030&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hv7vvRvBhvUvCkvvvvvjiPn2cv1j1hP2qZ1j3mPmPZQjYVR2qUlj3WRscw1j3W9phvheCJtJYwjHi47eWzz0kUsdS21IhCvCt%2Bc7LN%2Fa147DiJqYY8k%2BmMQgNTUQ3iAwVjSLrLoIk5vpvhvvmv99GCvvpvvPMMvphvC9vhvvCvpvyCvhQZLHhvC0eaKE5ErqO24gcE2f6A%2Be9nfa3liC4AVArlYExrV8td2ezpafm955X40f0DyBvOPZm93weaKdODoYjn%2Bv7ceLQWiRAEAf8QkphvC99vvOHgo4yCvv9vvUmgKVMaBbyCvm9vvvmbS6vvBQvv9DCvpvkjvvmmZhCv2CUvvUEpphvWQvvv9DCvpvsvRphvCvvvvvmjvpvhvvpvv2yCvvpvvvvvRphvCvvvvvmrvpvEvvsu9cEAvhCz&needFold=0&_ksTS=1589017813108_358&callback=jsonp359',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=604138791175&spuId=1365453425&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hv%2B9vRvBhvUvCkvvvvvjiPn2cv1j1hR2qvzjljPmP9sj1hRssh6jlHRLSUgjYndphvmZCvOQoRvhCa5syCvvBvpvvv9phvheCaPnYgjHi47eh2zAcj5d0kSIhCvCt%2BcZLNJn147DiJpaY8k%2BmMQgNTUQ3iAwVjSLrLoIk5vpvhphvhH2yCvvBvpvvv2QhvCvvvMMGEvpCWpXc4v8WzOvDYVVzvdiY6p5x2TWoXVcBWfCuYiLUpwh%2BFp%2B0xhCDAo2Ec6aZtn0vENB3r68gJEctz8dk1%2BFw5ZA9cAWQwejibwZbwtUyCvvXmp99WjEkivpvUphvh1c1%2BZw0tvpvIphvvcPMMpEHvpComvvCmI6CvHUUvvhPjphvZ99vvpznvpComvvC2wQhCvvXvppvvvvmjvpvhphhvv2yCvvBvpvvv&needFold=0&_ksTS=1589017850603_367&callback=jsonp368',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=587162329463&spuId=1152683778&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvFvvov7pvUvCkvvvvvjiPn2cv1j1hRsFUtjljPmP96jDEnLMvsji8n2zw1jDW9phvheCwCn%2FgjHi47eFZzAcj5d0kSIwCvvBvppvv2QhvCvvvMMGEvpCWpNG4v8RrwZwaUExreTgfN3%2Bulj7KHmx%2FwZEliC46NB9f8r3l5t3tozHb1W94ecxXnDeDyBvOJ193Zi7veB6AxsBCAfyprjlhwZJQ0fyCvm3vpvCwMMYvyZCvHUUvvh8FphvZ99vvpGavpComvvC2w6CvHUUvvhnskphvCyEmmvQwe8yCvv3vpvLHNVsPrQhCvvXvppvvvvvtvpvhphvvv8wCvvBvpvpZ9phvje1axnGczHi47emVz6u8QbM23MIFmV5EQOJYRln8k2yCvvBvpvvv9phvh0Hww%2FNNzHi47eNNz6FEAWTMAj%2Btvpvhphvvv86CvCCjBwhhmQCvLL1NSfyT%2Bkt4RphvChCvvvmrvpvBohyL2n%2BvpVwgw5lB%2B2hmOs8CvpvZ7DSkYs2w7Di49dN5MvC4FDdWz69%3D&needFold=0&_ksTS=1589017885037_383&callback=jsonp384',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=535456111084&spuId=686726405&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvlpvovZGvUvCkvvvvvjiPn2cv1j1HPLsWAj3mPmPwQjEHRssU0jimPLMOzj1H9phv2HifeSaBzHi475TGzT6CvvGOmU6vyiUv4HIidAUF4thtvpvhvvvvvUhCvCt%2BcxLN%2Fa147DiNIaY8k%2BmMQgNTUQ3iAwVjSLrLoI9tvpvhvvvvvvGCvvpvvPMMmphvLv3WJpvj4t7t5ah6Hkx%2Ftjc6D46fjL2p%2BExrVTtYmq0DyOvOHkx%2F1WClYb8rJooQD7zyditApWkQD70OeC69fc7QD40OaAd6D7zhV8TtvpvIvvvvkqYvvhwvvUEpphvU3Qvv9DCvpvQovvmmZhCv2WvvvUEpphvWQUyCvvOUvvVCJheivpvUvvmvKb33wnvCvpvVvvpvvhCviQhvCvvv9U8jvpvhvvpvv2yCvvpvvvvv9phvheCacnMtjHi47e81zAcj5d0kSu6CvvGOCHGvkOyvw8ZidAUF4thtvpvhvvvvv86CvvyvCmACT%2F%2BvyWU%3D&needFold=0&_ksTS=1589017920034_388&callback=jsonp389',
    'https://rate.tmall.com/list_detail_rate.htm?itemId=595693380034&spuId=1240723113&sellerId=884158406&order=3&currentPage=1&append=0&content=1&tagId=&posi=&picture=&groupId=&ua=098%23E1hvPQvxvcWvUpCkvvvvvjiPn2cv1j1HR2SOQj3mPmPv0jYjRLFZAjDWPsdhzjE8RLyCvvBvpvvv9phvHnsGKHTpzYswzW8N7%2FN9zCqw8DiIdphvmZCCrBvOvhC0T46CvvDvpfWWdvCv7Zytvpvhphvvv8wCvvBvpvpZRphvChCvvvvPvpvhvvvvvvyCvh1hcg9vIt3TmmxBlwyzhmx%2FaoF6D46fjLhiHWLUeii07FXXiXhpVj%2BOUx8x9E9XJ99DZacEn1viHmx%2Flj7NecnHaZMhzE97nDyiLO2vKphv8hCvvHsMM6mBphvZ99vvpunvpComvvC216CvHUUvvhnsphvZ99vvpzRivpvUphvh1cs%2BqLTEvpvVpyUU2CAOvphvCyCCvvvvvUwCvvBvppvv9phvj3gGtHd%2FzYswzHs975R2uU9E9fq2gFSEAUHU1%2BDsvsyCvvBvpvvv9phvhqQwCDzbqYswzbl57SELu7uUuwTrvpvEphj%2BHjQvpHG3dphvmZCC31ojvhCDGu6CvvDvpOgZCQCvwm8rvpvEphHAHE9vpjE6&needFold=0&_ksTS=1589017962052_384&callback=jsonp385']

for u in url[:]:
    Get_Url(u)
d = GetInfo(len(COMMENT_PAGE_URL))
d.to_csv('url.csv', encoding="utf-8-sig")
